*****************************
What's available for download
*****************************

When learning VBA, there's no substitute for watching how macros are constructed from start to finish, while listening to the programmer explain the reasons and methodology for the code being used.  

I recorded a total of 44 videos for the book that you can regard as your own VBA tutoring sessions. I have tried to explain the tasks at hand as if we were sitting at your computer, not only explaining what I am doing, but why. I strongly suggest that you watch all the videos. There are several hours of valuable information, plus a few tips and tricks that there was not enough room in the book to include.

This book and the videos are your first big step in a rewarding journey for learning how to program Excel to develop customized, automated workbook projects. I urge you to continue the journey; there is always something new to learn, whatever your skill level may be.

There are 33 lessons in the book, 29 of which are represented by a video based on the Try It section of that lesson. There are an additional 15 videos for advanced Excel programming techniques to expand your skills and awareness of VBA's power with Excel.

Lesson 1: Introducing VBA
No video provided.

Lesson 2: Getting Started with Macros
Video: Record a macro, assign a shortcut key to it, and run the macro.

Lesson 3: Introducing the Visual Basic Editor
No video provided.

Lesson 4: Working in the VBE
Video: Copy a macro from an external source and paste into an Excel VBA module.

Lesson 5: Object-Oriented Programming - An Overview
No video provided.

Lesson 6: Variables, Data Types, and Constants
Video: Practice manipulating and concatenating a String type variable.

Lesson 7: Understanding Objects and Collections
Video: Demonstration of the IntelliSense tool for familiarization with VBA syntax. 

Lesson 8: Working with Ranges
Video: Identify the range of cells by the columns and rows occupied by an embedded chart object.

Lesson 9: Making Decisions with VBA
Video: Message box and InputBox request the password to unprotect a worksheet.

Lesson 10: Repeating Actions with Loops
Video: Add 12 worksheets, each named by calendar month.

Lesson 11: Programming Formulas
Video: Sum numbers for columns of varying cells. 

Lesson 12: Working with Arrays
Video: Test the existence of a string being included in an array.

Lesson 13: Automating Procedures with Worksheet Events
Video: Running sum of numeric entries for cells in column A.

Lesson 14: Automating Procedures with Workbook Events
Video: BeforePrint event to hide confidential data from being printed.

Lesson 15: Handling Duplicate Items and Records
Video: From a large table, copy each set of matching records to their own workbook.

Lesson 16: Using Embedded Controls
Video: Three-way toggle with one Form button to hide or show portions of worksheet.

Lesson 17: Programming Charts
Video: Create a pie chart and embed it to a worksheet location.

Lesson 18: Programming PivotTables and PivotCharts
Video: Create a PivotChart and embed it below and existing PivotTable.

Lesson 19: User-Defined Functions
Video: Return the text of another cell's comment.

Lesson 20: Debugging Your Code
Video: Locate the address of a cell containing a value using the Find method.

Lesson 21: Creating UserForms
Video: Overview of basic UserForm construction and placement of controls.

Lesson 22: UserForm Controls and Their Functions
Video: Transfer selected items from a ListBox control to the worksheet.

Lesson 23: Advanced UserForms
Video: Create a web browser with a UserForm.

Lesson 24: Class Modules
Video: Involve some, but purposely not all, OptionButtons from a UserForm to respond to an event.

Lesson 25: Add-ins
Video: Create and load an add-in that returns the text of another cell's comment.

Lesson 26: Managing External Data
Video: Access the United States Navy's Master Clock to import the current time and date for North American time zones.

Lesson 27: Data Access with ActiveX Data Objects
No video provided.

Lesson 28: Impressing Your Boss (or at Least Your Friends)
Video: Establish a cell's data validation using a new custom list for the allowable drop down items.
 
Lesson 29: Overview of Office Automation From Excel
Video: Open a PowerPoint Presentation file.

Lesson 30: Working with Word From Excel
Video: Open a Word document that is requested of the user through an InputBox.

Lesson 31: Working with Outlook From Excel
Video: Create an email with multiple recipients, and attach the active workbook.

Lesson 32: Working with Access From Excel
Video: Add a new field to a table of an existing database.

Lesson 33: Working with PowerPoint From Excel
Video: Copy an embedded chart to an open PowerPoint's active presentation slide.

Advanced Lesson 1: Controlling Your PivotTable Drill Down Destinations
Video: Direct a pivot table's drill down recordsets to a dedicated worksheet or workbook. 

Advanced Lesson 2: Customizing Your Right-Click Menu to Run Macros
Video: Install a custom button on your right-click menu with a flyout list of macro names. 

Advanced Lesson 3: Guiding the Selection and Entry of Unambiguous Dates
Video: Present an interface of either a dialog sheet or userform to select a particular date.

Advanced Lesson 4: Adding a Customized Drop-Down List to Your Ribbon or Menu Bar
Video: A drop-down list on the Ribbon or menu bar shows unhidden worksheets that can be activated by clicking their names.

Advanced Lesson 5: Making Cells or Their Values Blink
Video: Demonstrates ways to make an embedded object, cell, range of cells, or values in cells blink on and off.

Advanced Lesson 6: Customizing Your Comments by Size, Text Formats, and Picture Fill
Video: Add a picture to a comment manually or by an event. Customize the comment shape's size and font style.

Advanced Lesson 7: Creating a Worksheet Tab Name Change Event
Video: Alert the user when the original name of a worksheet tab has changed.

Advanced Lesson 8: Formatting Individual Words or Characters
Video: Format a word with a contrasting color and font style to easily identify it in a text string.

Advanced Lesson 9: Restricting a TextBox's Data Entry for Numbers and Text
Video: Enforce rules for TextBox entry to allow or disallow text and numbers.

Advanced Lesson 10: Placing a Progress Bar on a UserForm
Video: A progress bar and its associated text on the status bar advise the user of a macro's progress toward completion.

Advanced Lesson 11: Filtering by Columns
Video: Filter columns instead of rows with either of two interface methods, one using data validation and the other a UserForm.

Advanced Lesson 12: Listing a Calendar Year's Dates by Day, Week Number, and Quarter
Video: For a calendar year, list its dates in column A, and for each date, its weekday name, its week number, and its quarter.

Advanced Lesson 13: Running a Macro from a Function Key
Video: Change the default behavior of a function key to run a specified macro for the active workbook.

Advanced Lesson 14: Listing Your Workbooks and Hyperlinking to Them
Video: List workbook names (or any other file type) from a specified folder and hyperlink each file's name to open it. 

Advanced Lesson 15: Customizing a Right-Click Menu for Your UserForm Controls
Video: Install a custom right-click menu for a UserForm control to show a list of tasks assigned to macros.